Discover Pro Ribbons

Open the Actions wizard to define actions for the query.

Enable Auto Run to automatically run the query when chips are selected/ added to the drop zones. If you choose to disable Auto Run, you can manually run your queries by clicking the main Pyramid button in the top left hand corner. When the query needs to be run, the following alert will appear:

Click the drop down and select a visualization type from the menu.

Open the chat bot to query the data model by asking analytical questions in plain English,

Click to open the Workflow or Conversations panel.

Use the font size icons to enlarge or shrink the font size. Use the font color icon to change the color of the title. Use the paint icon to change the canvas color.

View, edit, or delete quick variable list parameters.

Use the Members Search wizard to quickly search for members and add them to the query or save them as a list.

Click to open a new Discovery window. To copy a report, click the drop down and select Duplicate.

Switch the columns with rows, or reverse the x and y axes.

Click to remove all selections and reset the query.

Refresh the metadata in the trees, and the folder tree if showing business logic.

The workspace refers to the panels that make up the Discover module (Dimensions, Measures, Elements, and Drop Zones). These panels can be moved and placed in the make docks on either the right or left hand-side of the canvas. Click Workspace Type to undo any changes made to the workspace. Click the drop down to choose a preset.

Split the canvas horizontally or vertically and show the raw results nest to the visualization you've built.

Configure sorting and filtering preferences via the Sort Wizard and the Filter Wizard. Click the drop down and select either sort or filter. You can also remove previously applied sorts and filters from this drop down.

Select the drop down to reposition the grid on the canvas. Only available for matrix grids.

Display every other row in gray.

Show or hide axes labels. Click the drop down and select More to change font.

Customize the axes font and alignment.

Use a common scale, shared y-axis, shared x-axis, and select axis formats.

Click the drop down to select the position of the axis.

Hide or show axes.

Change the background color of the visualization.

Change the color of the visualization borders.

Use the border icons to make the visual's borders thicker or thinner.

Change the design of the chart output.

Toggle on to auto fit columns to the appropriate size to display the data in the cells.

Customize the cell font and alignment.

Add value labels to charts.

For line and area charts, click to show data points. For scatter charts, click the drop down to select the type of data point.

Use the Expand Icons to expand down to the next level in a grid. These will only operate on regular hierarchies.

Separate the segments.

Select a font color.

The functions available from the Format All section of the grid component ribbon are used for formatting of grids, grid rows, columns, cells, and headers. They can also be used to configure contextual formatting. Click here to learn more.

Specify a country and state.

Click the drop down to choose between matrix mode and flat mode. Only available for matrix grids.

Show or hide grid lines. Click the drop down to select from different types of grid lines, or select More to configure grid lines manually.

Add padding to the grid cells.

Hide or show headers. Change header font and colors by clicking the drop down and selecting More.

Align the gauge labels.

Click the drop down and select Edit Labels to edit the labels for the Target and/ or Value.

Enable or disable legends. Click the drop down to reposition the legend, and click more to change the legend's font, borders, and background color.

Toggle the line icons to make the line thicker or thinner .

Change the color of the countries and the water.

Select a map type from the drop down menu.

Enable the mini map to navigate large grids for easily.

When working with the motion drop zone, position the Motion component and determine the motion speed.

Drop a date hierarchy into the Motion drop zone to see the visualization change over time.

Add a title to charts.

Reduce the opacity of chart visuals.

Toggle the point icons to adjust the size of the data points.

Scale a grid down to fit on the canvas.

Use the text icons to enlarge and shrink the visual's font size.

Align the gauge titles.

Toggle gauge titles on and off.

Enable Auto Run to automatically run the query when chips are selected/ added to the drop zones. If you choose to disable Auto Run, you can manually run your queries by clicking the main Pyramid button in the top left hand corner.

Click the drop down to enable or disable cache, or revert to the model's default cache options.

Click the drop down to select a language. Choose Default to select the default language set in the cube.

Note: Available only with MS OLAP, Tabular and SAP models.

Use the Eliminations wizard to eliminate specified members from the query.

Configure filtering preferences via the Filter Wizard. Click the drop down and select filter.

Use forecasting to project future values in a time series, such as sales over the next quarter.

Use the K-Means Cluster algorithm to divide your chart into k clusters.

Click to enable colors defined in the cube.

Available only with MS OLAP and Tabular models.

Click to enable formats defined in the cube.

Available only with MS OLAP and Tabular models.

Open the N-of-N wizard to configure nested loop queries.

Divide your chart into "in" an "out" to show outliers.

Switch the columns with rows, or reverse the x and y axes.

Click to remove all selections and reset the query.

A set of optimization switches that can be used to tweak the manner in which a query is executed. To learn about Query Settings, click here.

Available only with MS OLAP, Tabular and SAP models.

Refresh the metadata in the trees, and the folder tree if showing business logic.

Use regression lines with charts (not including pie, doughnut, pyramid, funnel, and map charts) to calculate trend regressions, using one of four models against a data series in the chart.

Click to show empty rows and columns. Click the drop down to show or hide all empties.

Configure sorting preferences via the Sort Wizard. Click the drop down and select sort or filter.

Use the Statistics functions with charts (not including pie, doughnut, pyramid, funnel, and map charts) to integrate statistical information within the plot area of the chart, and view the average or median on top of the chart.

Use the Time Calculation wizard to quickly build complex formulas based on time.

Click to add grand totals to a grid. Select the drop down to configure totals rows and/or columns from the dialog.